UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W0k6MxY3unYQBk1Eu47y4UfQYVUgzTPjC2RgC1l3CHU='
WHERE
key_id = '99e78f753bbaf19cd1440c40918b0c3b4e852447ff14d234b1f44d01a49942df'
AND (
token = 'W0k6MxY3unYQBk1Eu47y4UfQYVUgzTPjC2RgC1l3CHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)