UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'weVCcqh5teJH8Cl6R/tX5UjZb0TCUFdCGfvW+tGOy9w='
WHERE
key_id = 'd6add9b01cef351791b29ba22426c72043bb86d4498a5964990b7fdc4b734224'
AND (
token = 'weVCcqh5teJH8Cl6R/tX5UjZb0TCUFdCGfvW+tGOy9w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)