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