UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6ghoMZackcB0wNFhPoTdkvbUIwDMIiKUNTuR+4kWQi0='
WHERE
key_id = 'b605bec3f562e37e2f9e083f24776b78aa08d72b3b65d83a95cd12ae6888bf92'
AND (
token = '6ghoMZackcB0wNFhPoTdkvbUIwDMIiKUNTuR+4kWQi0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)