UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7iTbwXmL8mBjZCSbOuoxHue9ESyRF23K/TyOrubxeUo='
WHERE
key_id = '825913f7845fa68baccea9dd71b4347c23c771989936067f8562e6c21273a29c'
AND (
token = '7iTbwXmL8mBjZCSbOuoxHue9ESyRF23K/TyOrubxeUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)