UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6J86D3OatAuh7LVmzt4AYZ9wY6b9P/DqmOhbI7J5yfY='
WHERE
key_id = 'e8faa9433cceabc5832e54a04f85f776a800ad5bc2feaa23a8c3538dd911e880'
AND (
token = '6J86D3OatAuh7LVmzt4AYZ9wY6b9P/DqmOhbI7J5yfY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)