UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b/qjDHMu3fsJzlrH3VxIlrs0JdawgmLy3ZZ3gX8VTO0='
WHERE
key_id = '3d9f7805c1aacd8a7fa3c92940c5c176800a0ddb7781a3883d8ad72b59900604'
AND (
token = 'b/qjDHMu3fsJzlrH3VxIlrs0JdawgmLy3ZZ3gX8VTO0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)