UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5xW6Dx9Lz3/nSjB6MB6zoLeAf6KiZtS8WNKyiTHLcCA='
WHERE
key_id = '4a6c32dfa82415ef8561f3634467fa87e6307fe03e0f8681435de019368ab3a6'
AND (
token = '5xW6Dx9Lz3/nSjB6MB6zoLeAf6KiZtS8WNKyiTHLcCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)