UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YnKH7OZoFKV7ZvsbtH3SPdKvjlCkBNho5bZowffLSbw='
WHERE
key_id = '5efed22e28817485fe8066a6b29360343d54a206ab53b94ac387703a30f143b8'
AND (
token = 'YnKH7OZoFKV7ZvsbtH3SPdKvjlCkBNho5bZowffLSbw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)