UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sDGLgVTA77K7aiNVkh+JyZzH6Haiy3A8pcnyaqXx+R4='
WHERE
key_id = 'abb8c642e22b96cad4569f15a540511128daf0ba4cd063fd43be4a539902807c'
AND (
token = 'sDGLgVTA77K7aiNVkh+JyZzH6Haiy3A8pcnyaqXx+R4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)