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