UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VfziTq0+pm88zDoNps5FRrkFNfAnXk4mzYBbgTi3OIE='
WHERE
key_id = 'ef62c05c624e2afb5da45b86d8437c08549d3f3ab30e50793badf4a665fc9159'
AND (
token = 'VfziTq0+pm88zDoNps5FRrkFNfAnXk4mzYBbgTi3OIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)