UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '05OKuzRy8EGR7ekaCi0trqEzao4M5FgF8Ka+M8ccGf4='
WHERE
key_id = '3213eb73915125594dfa10876045e8a87017191a55a77f10e9f3dbb65b0de9f8'
AND (
token = '05OKuzRy8EGR7ekaCi0trqEzao4M5FgF8Ka+M8ccGf4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)