UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4KZf0O7cWa42vwpAY7yL5Vsf555Y0pjHYeBXqUXpIHQ='
WHERE
key_id = 'c729e2e644dccf018dee85ddd48af8ea38d4e863342ad1deac8a8ece69a8e35c'
AND (
token = '4KZf0O7cWa42vwpAY7yL5Vsf555Y0pjHYeBXqUXpIHQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)