UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ns8NtwO4CSoswkMx3FvLuO7PUWvxNcOsfE6afHgGDhg='
WHERE
key_id = '5b0cb0ca091b65759cd7c61cb71de3a41184038e6607418393353812510ec08a'
AND (
token = 'Ns8NtwO4CSoswkMx3FvLuO7PUWvxNcOsfE6afHgGDhg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)