UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9GlJfZC21SyovVDvcTtydcViICj7txf6dRWItdLu6CA='
WHERE
key_id = 'f595c14798c2f765b0fd1100c345b9e67f381e6b5c9fc3860837581b68972bb1'
AND (
token = '9GlJfZC21SyovVDvcTtydcViICj7txf6dRWItdLu6CA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)