UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9a8QjSolORoo7wvVTYzs7c91vfxxvhdqlK/GcBBFZqU='
WHERE
key_id = '508261b787c82e9d31b923822dac0f3e29dc7dffcec9341358a192d8b85ca967'
AND (
token = '9a8QjSolORoo7wvVTYzs7c91vfxxvhdqlK/GcBBFZqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)