UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5An5G5SkQ9Y3uktEsvR2GxIVkHx3U8SoiPeU4+HQeCc='
WHERE
key_id = '2d7b9166eb413bced01fcb5197e459c016a6c2606ea1214873b7a315d9b6c182'
AND (
token = '5An5G5SkQ9Y3uktEsvR2GxIVkHx3U8SoiPeU4+HQeCc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)