UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DObNK1mhV/oVU1r95xqLrhfuTqxGvHRjGY7a1PlnA+c='
WHERE
key_id = '71d9b392087319321f7bf69c544b1680a829fb4257730c6a056a8cf1d9b677b2'
AND (
token = 'DObNK1mhV/oVU1r95xqLrhfuTqxGvHRjGY7a1PlnA+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)