UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W2u0lQJBjdKbMsjIrOpxTjm7eaYxTo4Vl3oLBFmbfEM='
WHERE
key_id = '6cd8c8129e6ea02cbee0ffa2d6cfec0346cc0264e96e8af0903f5a5a2ee1228f'
AND (
token = 'W2u0lQJBjdKbMsjIrOpxTjm7eaYxTo4Vl3oLBFmbfEM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)