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