UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o3E9yi0bnUxd4OyQlf0DXv2CzQkCtmqlGq9vfYhhjhM='
WHERE
key_id = 'bed509ab12931bcd0c33edf2b41b9974c94980da6cd545da0c112ca099f63a0a'
AND (
token = 'o3E9yi0bnUxd4OyQlf0DXv2CzQkCtmqlGq9vfYhhjhM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)