UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4LkyD//r4c6W2kw5XAUAKKoXoFF1JI1t0XCVkK7eweA='
WHERE
key_id = '9ad204efccf7410867f4da47a45a7738372614bbd0caf4d94e39ab75117a77de'
AND (
token = '4LkyD//r4c6W2kw5XAUAKKoXoFF1JI1t0XCVkK7eweA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)