UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4SkcGh0paLbC7CWDRN2ZJrDVVpNhwxSh9c72j6B1Xiw='
WHERE
key_id = 'd6f2dd3ae612df534f92eff1ec405077aab71aeaf949643b40c36f904b6eeaa4'
AND (
token = '4SkcGh0paLbC7CWDRN2ZJrDVVpNhwxSh9c72j6B1Xiw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)