UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zU5gipe6raufrYTQE7D/D+sIL8dfnv0c4B0pxTngniY='
WHERE
key_id = '76e146d96d4b70d4cd5861663564de36b101ab89b3ea4c4767a48731ae1a3fac'
AND (
token = 'zU5gipe6raufrYTQE7D/D+sIL8dfnv0c4B0pxTngniY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)