UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pRNXlhd9RJalL1ODUGI1/1/v6+U+W3A2+wz3sKRpy8c='
WHERE
key_id = '5154c278a8d7d246abef422922c3d1f8bbf232afebb4a6ec35792583a3fb387b'
AND (
token = 'pRNXlhd9RJalL1ODUGI1/1/v6+U+W3A2+wz3sKRpy8c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)