UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LBPXn4kh6POg4diAtGlyLHD1YhkeS3/Qjzn2auR6fkw='
WHERE
key_id = 'c722afc193ee29eb966ed76d3f3b21e79a08248bb0d4575eaf4fed1078b2e196'
AND (
token = 'LBPXn4kh6POg4diAtGlyLHD1YhkeS3/Qjzn2auR6fkw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)