UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5ijY9egJS8DXKHuaj9slVLv2R5dtkSOjOyMpLgYlLh8='
WHERE
key_id = '3c3d3961d45a7172db8236d40cc9cf1661e516def8c5bfd5b55dadbfa5ed59f7'
AND (
token = '5ijY9egJS8DXKHuaj9slVLv2R5dtkSOjOyMpLgYlLh8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)