UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C10/tG3PyWS7Oze01GQ+rcilyUS5zInAU+GL2nwzgaI='
WHERE
key_id = 'b4faa1e7db2d7d190174779473b2a8fdc26c01b8eab60df40053ad586948b041'
AND (
token = 'C10/tG3PyWS7Oze01GQ+rcilyUS5zInAU+GL2nwzgaI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)