UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0tdLnKWctIkIDkQswTx5WPk3Qxfha952sD6Olw6/OCg='
WHERE
key_id = 'f8df4a2d0920551d3536e39a0ae1554fe72838116fc9b76643d13c5257beaf7e'
AND (
token = '0tdLnKWctIkIDkQswTx5WPk3Qxfha952sD6Olw6/OCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)