UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SgJI4SvrbZJ/YD4Mdh3IAvs6WFEyI3+d7nRMQRrQsmo='
WHERE
key_id = 'd2b0768675aa6607a8b3e3d1b50d10beec20b237f99575c8b25ef560830d3328'
AND (
token = 'SgJI4SvrbZJ/YD4Mdh3IAvs6WFEyI3+d7nRMQRrQsmo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)