UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6TfooPyN3R4nThLRW6tDbRkk8p7XXlYZnTLq/M1BX1s='
WHERE
key_id = '38837c4dc454b6f5be7a3fe9802cd053fbd7946c869904ef83909f6b94379b0c'
AND (
token = '6TfooPyN3R4nThLRW6tDbRkk8p7XXlYZnTLq/M1BX1s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)