UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9UHT6Pthq/0B0NABUHDmHPbYl1MVOMEWuPUXFXUEvd4='
WHERE
key_id = '8227c3345471fa2daac192a20a3b3b7645c6cc513eb969d5e88ea9049b4d0f6d'
AND (
token = '9UHT6Pthq/0B0NABUHDmHPbYl1MVOMEWuPUXFXUEvd4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)