UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '65cx3jYJptJgK5A74iJg5DAtD/E2pUZbCF33wcFBtCs='
WHERE
key_id = '5267be1f0f30b998a02f54905e5217cb17861eea3f53a12484b71ae947697aca'
AND (
token = '65cx3jYJptJgK5A74iJg5DAtD/E2pUZbCF33wcFBtCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)