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